package vip.xiaonuo.smzq.modular.kcl.mapper;

import org.apache.ibatis.annotations.Select;
import vip.xiaonuo.smzq.modular.kcl.entity.Wjglb;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;

/**
 * 资料上传文件关联表 Mapper
 *
 * @author sqq
 * @since 2024-03-13
 */
@Mapper
public interface WjglbMapper extends BaseMapper<Wjglb> {
     @Select("SELECT STRING_AGG(pkid, ',')  AS pkid_list FROM kcl_wjglb where zlsc_id=#{pkid}")
    String selectFileId(String pkid);
  @Select("select * from kcl_wjglb where pkid=#{fileId}")
    Wjglb selectFile(String fileId);
}
